Mergecontentdbs gives a "Database Not Found" Error
Hi, Trying to split our SP 2007 content DB's to smaller chunks and get the "Database Not Found error" I double checked the DB srver and the database exists as I created it and have full control over it. I ran te stsadm "enumcontentdbs"to check the dbs and it exists but still get the error. C:\>stsadm -o enumcontentdbs -url http://qm-unite.grouphc.net <Databases Count="1"> <ContentDatabase Server="GRPSDHEID0003" Name="WSS_Content_Unite_QM" /> </Databases> C:\>stsadm -o mergecontentdbs -url http://qm-unite.grouphc.net -sourcedatabasena me WSS_Content_Unite_QM -destinationdatabasename WSS_Content_Team_QM -operation 1 Database not found. C:\> Any Suggestions? Regards SS sabu
May 4th, 2011 2:37pm

Hello, What method did you use to split them? Thanks! TomTom Molskow - SharePoint Architect - Microsoft Community Contributor 2011 Award - Linked-In - SharePoint Gypsy
Free Windows Admin Tool Kit Click here and download it now
May 5th, 2011 3:16pm

Hi Sabu21s, Please refer to the following two articles to see if your problem is similar with any of them, and then try the solutions there. Maybe this could help you to solve this issue: http://www.sharepoint-insight.com/2009/07/21/sharepoint-wss-3-0-sql-database-not-found-error/; http://cs.grossmann.com/blogs/fg/archive/2007/07/08/sharepoint-wss-2-0-to-wss-3-0-moss-2007-experiences.aspx. Thanks & Regards, Peng Lei
May 5th, 2011 9:35pm

Hi Sabu21s, Here's a good article on how to add, split and merge SP databases: http://technet.microsoft.com/en-us/library/cc825326(office.12).aspx Thanks! Tom Tom Molskow - SharePoint Architect - Microsoft Community Contributor 2011 Award - Linked-In - SharePoint Gypsy
Free Windows Admin Tool Kit Click here and download it now
May 6th, 2011 8:21am

Here's a good article on how to add, split and merge SP databases: I forgot to add it to a web app via CA... Here what I did... 1) First Add Db's to the web Apps in Central Admin 2) Command to Read from File: C:\>stsadm -o mergecontentdbs -urlp://mysiteurl -sourcedatabasename WSS_Content_QM -destinationdatabasename WSS_Content_test_QM -operation 3 -filename D:\Merge\site.xml 3) After the Merge is done do the following: Do an IIS Reset on all servers Start the Full Crawl (Important) sabu
May 6th, 2011 10:10am

Hi Sabu21s, Here's a good article on how to add, split and merge SP databases: http://technet.microsoft.com/en-us/library/cc825326(office.12).aspx Thanks! Tom Tom Molskow - SharePoint Architect - Microsoft Community Contributor 2011 Award - Linked-In - SharePoint Gypsy I forgot to add it to a web app via CA... Here what I did... 1) First Add Db's to the web Apps in Central Admin 2) Command to Read from File: C:\>stsadm -o mergecontentdbs -urlp://mysiteurl -sourcedatabasename WSS_Content_QM -destinationdatabasename WSS_Content_test_QM -operation 3 -filename D:\Merge\site.xml 3) After the Merge is done do the following: Do an IIS Reset on all servers Start the Full Crawl (Important)sabu
Free Windows Admin Tool Kit Click here and download it now
May 6th, 2011 10:11am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics